SQL Queries
To get All Tables in Database:
select * from sysobjects where xtype='U'
Exp.
SELECT name FROM sysobjects WHERE xtype='U' ORDER BY name ASC
To get All Tables and Respective Columns:
select A.name,c.name from sysobjects A inner join syscolumns c on a.id= c.id where A.xtype='U'
Exp.
SELECT A.name,C.name FROM sysobjects A inner join syscolumns C on A.id=C.id WHERE A.xtype='U' AND A.name='{tableName}' ORDER BY A.name ASC
*since i always forget many things, i learn my senior Satish to put them in the blog to help in memorizing.

Recent Comments